SELECT
<#switch (object_id!)>
<#case "beginDate">
BEGIN_DATE AS beginDate
<#break>
<#case "code">
CODE AS code
<#break>
<#case "createdByCode">
CREATED_BY_CODE AS createdByCode
<#break>
<#case "createdById">
CREATED_BY_ID AS createdById
<#break>
<#case "createdByName">
CREATED_BY_NAME AS createdByName
<#break>
<#case "createdDate">
CREATED_DATE AS createdDate
<#break>
<#case "dataStateCode">
DATA_STATE_CODE AS dataStateCode
<#break>
<#case "dataStateId">
DATA_STATE_ID AS dataStateId
<#break>
<#case "dataStateName">
DATA_STATE_NAME AS dataStateName
<#break>
<#case "endDate">
END_DATE AS endDate
<#break>
<#case "explainText">
EXPLAIN_TEXT AS explainText
<#break>
<#case "id">
ID AS id
<#break>
<#case "lastModifiedByCode">
LAST_MODIFIED_BY_CODE AS lastModifiedByCode
<#break>
<#case "lastModifiedById">
LAST_MODIFIED_BY_ID AS lastModifiedById
<#break>
<#case "lastModifiedByName">
LAST_MODIFIED_BY_NAME AS lastModifiedByName
<#break>
<#case "lastModifiedDate">
LAST_MODIFIED_DATE AS lastModifiedDate
<#break>
<#case "name">
NAME AS name
<#break>
<#case "orderNum">
ORDER_NUM AS orderNum
<#break>
<#case "parentCode">
PARENT_CODE AS parentCode
<#break>
<#case "parentId">
PARENT_ID AS parentId
<#break>
<#case "parentName">
PARENT_NAME AS parentName
<#break>
<#case "remark">
REMARK AS remark
<#break>
<#case "stateCode">
STATE_CODE AS stateCode
<#break>
<#case "stateId">
STATE_ID AS stateId
<#break>
<#case "stateName">
STATE_NAME AS stateName
<#break>
<#case "treeCode">
TREE_CODE AS treeCode
<#break>
<#case "treeId">
TREE_ID AS treeId
<#break>
<#case "treeName">
TREE_NAME AS treeName
<#break>
<#case "typeCode">
TYPE_CODE AS typeCode
<#break>
<#case "typeId">
TYPE_ID AS typeId
<#break>
<#case "typeName">
TYPE_NAME AS typeName
<#break>
<#case "typeTreeCode">
TYPE_TREE_CODE AS typeTreeCode
<#break>
<#case "typeTreeId">
TYPE_TREE_ID AS typeTreeId
<#break>
<#case "typeTreeName">
TYPE_TREE_NAME AS typeTreeName
<#break>
<#case "value">
VALUE AS value
<#break>
<#case "versionInt">
VERSION_INT AS versionInt
<#break>
    <#default>
        COUNT(1) AS COUNT_
        </#switch>
        FROM c1_dictionary
        <#include
        "whereByCode.ftl">